//  Copyright (c) 2010, Keith Nixon, Sales Engineering, Salesforce.com Inc.
//  All rights reserved.
//
//  Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
//  Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. 
//  Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
//  Neither the name of the salesforce.com nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission. 
//  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
//  INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
//  DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, 
//  SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; 
//  LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN 
//  CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, 
//  EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
//
//  *NB - This is NOT a bulkified trigger
//
//  History
//
//  Version  Date            Author          Comments
//  1.0      19-01-2011      Keith Nixon     Initial version. Sets the completeness of an outlet based on the
//                                           corresponding completeness of the outlet objectives.
//
//  ***** THIS IS NOT A BULK CONTRACT
//

trigger SetAccountObjectiveCompletenessAfterUpdate on Outlet_Objectives__c (after update) {
    Outlet_Objectives__c oo = Trigger.new.get(0);
    
    If(oo.Account__c != null)
    {
        if(oo.Status__c != null && oo.Status__c.equalsIgnoreCase('completed'))
        {
            //query for all of the outlet objectives for the associated account
            List<Outlet_Objectives__c> objectives = [
                Select Id, Status__c From Outlet_Objectives__c Where Account__c =: oo.Account__c
            ];
            
            Integer numObjectives = objectives.size();
            Integer completedObjectivesAccount = 0;
            for(Outlet_Objectives__c obj : objectives)
            {
                if(obj.Status__c != null && obj.Status__c.equalsIgnoreCase('completed'))
                {
                    completedObjectivesAccount++;
                }
            }
            
            if(completedObjectivesAccount == numObjectives)
            {
                Account a = [Select Objectives__c From Account Where Id =: oo.Account__c LIMIT 1];
                a.Objectives__c = 'Completed';
                upsert a;
            }
        }
    }
}